{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "\n",
    "df = pd.read_csv(\"surveydata/datetime.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-03-13 08-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-03-13 07-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-03-13 06-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-03-13 05-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-03-13 04-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2020-03-13 03-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.39</td>\n",
       "      <td>128.90</td>\n",
       "      <td>116.06</td>\n",
       "      <td>124.85</td>\n",
       "      <td>7378976.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2020-03-13 02-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>134.03</td>\n",
       "      <td>137.90</td>\n",
       "      <td>125.50</td>\n",
       "      <td>128.39</td>\n",
       "      <td>3733916.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020-03-13 01-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.35</td>\n",
       "      <td>140.95</td>\n",
       "      <td>128.99</td>\n",
       "      <td>134.03</td>\n",
       "      <td>9582732.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2020-03-13 12-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.93</td>\n",
       "      <td>134.60</td>\n",
       "      <td>126.95</td>\n",
       "      <td>131.35</td>\n",
       "      <td>3906590.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2020-03-13 11-AM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>132.60</td>\n",
       "      <td>133.17</td>\n",
       "      <td>126.01</td>\n",
       "      <td>128.93</td>\n",
       "      <td>3311080.29</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Date  Symbol    Open    High     Low   Close      Volume\n",
       "0  2020-03-13 08-PM  ETHUSD  129.94  131.82  126.87  128.71  1940673.93\n",
       "1  2020-03-13 07-PM  ETHUSD  119.51  132.02  117.10  129.94  7579741.09\n",
       "2  2020-03-13 06-PM  ETHUSD  124.47  124.85  115.50  119.51  4898735.81\n",
       "3  2020-03-13 05-PM  ETHUSD  124.08  127.42  121.63  124.47  2753450.92\n",
       "4  2020-03-13 04-PM  ETHUSD  124.85  129.51  120.17  124.08  4461424.71\n",
       "5  2020-03-13 03-PM  ETHUSD  128.39  128.90  116.06  124.85  7378976.00\n",
       "6  2020-03-13 02-PM  ETHUSD  134.03  137.90  125.50  128.39  3733916.89\n",
       "7  2020-03-13 01-PM  ETHUSD  131.35  140.95  128.99  134.03  9582732.93\n",
       "8  2020-03-13 12-PM  ETHUSD  128.93  134.60  126.95  131.35  3906590.52\n",
       "9  2020-03-13 11-AM  ETHUSD  132.60  133.17  126.01  128.93  3311080.29"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(23674, 7)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'str' object has no attribute 'day_name'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-28-6e44d82815e7>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"Date\"\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mday_name\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;31m# Date column is string right now\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: 'str' object has no attribute 'day_name'"
     ]
    }
   ],
   "source": [
    "df.loc[0, \"Date\"].day_name() # Date column is string right now "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Date\"] = pd.to_datetime(df[\"Date\"], format=\"%Y-%m-%d %I-%p\") # converting date string in to date format"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       2020-03-13 08:00:00\n",
       "1       2020-03-13 07:00:00\n",
       "2       2020-03-13 06:00:00\n",
       "3       2020-03-13 05:00:00\n",
       "4       2020-03-13 04:00:00\n",
       "                ...        \n",
       "23669   2017-07-01 03:00:00\n",
       "23670   2017-07-01 02:00:00\n",
       "23671   2017-07-01 01:00:00\n",
       "23672   2017-07-01 12:00:00\n",
       "23673   2017-07-01 11:00:00\n",
       "Name: Date, Length: 23674, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Date\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Friday'"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0, \"Date\"].day_name() # getting weekday of one row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          Friday\n",
       "1          Friday\n",
       "2          Friday\n",
       "3          Friday\n",
       "4          Friday\n",
       "           ...   \n",
       "23669    Saturday\n",
       "23670    Saturday\n",
       "23671    Saturday\n",
       "23672    Saturday\n",
       "23673    Saturday\n",
       "Name: Date, Length: 23674, dtype: object"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Date\"].dt.day_name() # getting weekday of all the rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Day Of Week\"] = df[\"Date\"].dt.day_name() # making an other column for the day of week"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Day Of Week</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-03-13 08:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-03-13 07:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-03-13 06:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-03-13 05:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-03-13 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23669</th>\n",
       "      <td>2017-07-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>265.74</td>\n",
       "      <td>272.74</td>\n",
       "      <td>265.00</td>\n",
       "      <td>272.57</td>\n",
       "      <td>1500282.55</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23670</th>\n",
       "      <td>2017-07-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>268.79</td>\n",
       "      <td>269.90</td>\n",
       "      <td>265.00</td>\n",
       "      <td>265.74</td>\n",
       "      <td>1702536.85</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23671</th>\n",
       "      <td>2017-07-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>274.83</td>\n",
       "      <td>274.93</td>\n",
       "      <td>265.00</td>\n",
       "      <td>268.79</td>\n",
       "      <td>3010787.99</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23672</th>\n",
       "      <td>2017-07-01 12:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>275.01</td>\n",
       "      <td>275.01</td>\n",
       "      <td>271.00</td>\n",
       "      <td>274.83</td>\n",
       "      <td>824362.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23673</th>\n",
       "      <td>2017-07-01 11:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>279.98</td>\n",
       "      <td>279.99</td>\n",
       "      <td>272.10</td>\n",
       "      <td>275.01</td>\n",
       "      <td>679358.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23674 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Date  Symbol    Open    High     Low   Close      Volume  \\\n",
       "0     2020-03-13 08:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93   \n",
       "1     2020-03-13 07:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09   \n",
       "2     2020-03-13 06:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81   \n",
       "3     2020-03-13 05:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92   \n",
       "4     2020-03-13 04:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71   \n",
       "...                   ...     ...     ...     ...     ...     ...         ...   \n",
       "23669 2017-07-01 03:00:00  ETHUSD  265.74  272.74  265.00  272.57  1500282.55   \n",
       "23670 2017-07-01 02:00:00  ETHUSD  268.79  269.90  265.00  265.74  1702536.85   \n",
       "23671 2017-07-01 01:00:00  ETHUSD  274.83  274.93  265.00  268.79  3010787.99   \n",
       "23672 2017-07-01 12:00:00  ETHUSD  275.01  275.01  271.00  274.83   824362.87   \n",
       "23673 2017-07-01 11:00:00  ETHUSD  279.98  279.99  272.10  275.01   679358.87   \n",
       "\n",
       "      Day Of Week  \n",
       "0          Friday  \n",
       "1          Friday  \n",
       "2          Friday  \n",
       "3          Friday  \n",
       "4          Friday  \n",
       "...           ...  \n",
       "23669    Saturday  \n",
       "23670    Saturday  \n",
       "23671    Saturday  \n",
       "23672    Saturday  \n",
       "23673    Saturday  \n",
       "\n",
       "[23674 rows x 8 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2017-07-01 01:00:00')"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Date\"].min() # checking the earlies date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2020-03-13 12:00:00')"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Date\"].max() # checking the latest date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timedelta('986 days 11:00:00')"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Date\"].max() - df[\"Date\"].min() # calculating the time between dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Day Of Week</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-03-13 08:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-03-13 07:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-03-13 06:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-03-13 05:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-03-13 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1744</th>\n",
       "      <td>2020-01-01 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.57</td>\n",
       "      <td>130.00</td>\n",
       "      <td>129.50</td>\n",
       "      <td>129.56</td>\n",
       "      <td>702786.82</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1745</th>\n",
       "      <td>2020-01-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.37</td>\n",
       "      <td>130.44</td>\n",
       "      <td>129.38</td>\n",
       "      <td>129.57</td>\n",
       "      <td>496704.23</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1746</th>\n",
       "      <td>2020-01-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.14</td>\n",
       "      <td>130.50</td>\n",
       "      <td>129.91</td>\n",
       "      <td>130.37</td>\n",
       "      <td>396315.72</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1747</th>\n",
       "      <td>2020-01-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.34</td>\n",
       "      <td>130.14</td>\n",
       "      <td>128.32</td>\n",
       "      <td>130.14</td>\n",
       "      <td>635419.40</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1748</th>\n",
       "      <td>2020-01-01 12:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.12</td>\n",
       "      <td>128.34</td>\n",
       "      <td>245119.91</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1749 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Date  Symbol    Open    High     Low   Close      Volume  \\\n",
       "0    2020-03-13 08:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93   \n",
       "1    2020-03-13 07:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09   \n",
       "2    2020-03-13 06:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81   \n",
       "3    2020-03-13 05:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92   \n",
       "4    2020-03-13 04:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71   \n",
       "...                  ...     ...     ...     ...     ...     ...         ...   \n",
       "1744 2020-01-01 04:00:00  ETHUSD  129.57  130.00  129.50  129.56   702786.82   \n",
       "1745 2020-01-01 03:00:00  ETHUSD  130.37  130.44  129.38  129.57   496704.23   \n",
       "1746 2020-01-01 02:00:00  ETHUSD  130.14  130.50  129.91  130.37   396315.72   \n",
       "1747 2020-01-01 01:00:00  ETHUSD  128.34  130.14  128.32  130.14   635419.40   \n",
       "1748 2020-01-01 12:00:00  ETHUSD  128.54  128.54  128.12  128.34   245119.91   \n",
       "\n",
       "     Day Of Week  \n",
       "0         Friday  \n",
       "1         Friday  \n",
       "2         Friday  \n",
       "3         Friday  \n",
       "4         Friday  \n",
       "...          ...  \n",
       "1744   Wednesday  \n",
       "1745   Wednesday  \n",
       "1746   Wednesday  \n",
       "1747   Wednesday  \n",
       "1748   Wednesday  \n",
       "\n",
       "[1749 rows x 8 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# checking the data for a certain date\n",
    "fltr1 = (df[\"Date\"] >= \"2020\") # setting the filter to filter the 2020 out\n",
    "df.loc[fltr1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Day Of Week</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1749</th>\n",
       "      <td>2019-12-31 11:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.33</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.14</td>\n",
       "      <td>128.54</td>\n",
       "      <td>440678.91</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1750</th>\n",
       "      <td>2019-12-31 10:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.38</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.95</td>\n",
       "      <td>128.33</td>\n",
       "      <td>554646.02</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1751</th>\n",
       "      <td>2019-12-31 09:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.86</td>\n",
       "      <td>128.43</td>\n",
       "      <td>127.72</td>\n",
       "      <td>128.38</td>\n",
       "      <td>350155.69</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1752</th>\n",
       "      <td>2019-12-31 08:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.84</td>\n",
       "      <td>128.34</td>\n",
       "      <td>127.71</td>\n",
       "      <td>127.86</td>\n",
       "      <td>428183.38</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1753</th>\n",
       "      <td>2019-12-31 07:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.60</td>\n",
       "      <td>127.84</td>\n",
       "      <td>1169847.84</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10504</th>\n",
       "      <td>2019-01-01 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.75</td>\n",
       "      <td>133.96</td>\n",
       "      <td>130.74</td>\n",
       "      <td>131.96</td>\n",
       "      <td>2791135.37</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10505</th>\n",
       "      <td>2019-01-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.75</td>\n",
       "      <td>503732.63</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10506</th>\n",
       "      <td>2019-01-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.88</td>\n",
       "      <td>129.55</td>\n",
       "      <td>130.06</td>\n",
       "      <td>838183.43</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10507</th>\n",
       "      <td>2019-01-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.62</td>\n",
       "      <td>131.62</td>\n",
       "      <td>130.77</td>\n",
       "      <td>130.79</td>\n",
       "      <td>434917.99</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10508</th>\n",
       "      <td>2019-01-01 12:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.53</td>\n",
       "      <td>131.91</td>\n",
       "      <td>130.48</td>\n",
       "      <td>131.62</td>\n",
       "      <td>1067136.21</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Date  Symbol    Open    High     Low   Close      Volume  \\\n",
       "1749  2019-12-31 11:00:00  ETHUSD  128.33  128.69  128.14  128.54   440678.91   \n",
       "1750  2019-12-31 10:00:00  ETHUSD  128.38  128.69  127.95  128.33   554646.02   \n",
       "1751  2019-12-31 09:00:00  ETHUSD  127.86  128.43  127.72  128.38   350155.69   \n",
       "1752  2019-12-31 08:00:00  ETHUSD  127.84  128.34  127.71  127.86   428183.38   \n",
       "1753  2019-12-31 07:00:00  ETHUSD  128.69  128.69  127.60  127.84  1169847.84   \n",
       "...                   ...     ...     ...     ...     ...     ...         ...   \n",
       "10504 2019-01-01 04:00:00  ETHUSD  130.75  133.96  130.74  131.96  2791135.37   \n",
       "10505 2019-01-01 03:00:00  ETHUSD  130.06  130.79  130.06  130.75   503732.63   \n",
       "10506 2019-01-01 02:00:00  ETHUSD  130.79  130.88  129.55  130.06   838183.43   \n",
       "10507 2019-01-01 01:00:00  ETHUSD  131.62  131.62  130.77  130.79   434917.99   \n",
       "10508 2019-01-01 12:00:00  ETHUSD  130.53  131.91  130.48  131.62  1067136.21   \n",
       "\n",
       "      Day Of Week  \n",
       "1749      Tuesday  \n",
       "1750      Tuesday  \n",
       "1751      Tuesday  \n",
       "1752      Tuesday  \n",
       "1753      Tuesday  \n",
       "...           ...  \n",
       "10504     Tuesday  \n",
       "10505     Tuesday  \n",
       "10506     Tuesday  \n",
       "10507     Tuesday  \n",
       "10508     Tuesday  \n",
       "\n",
       "[8760 rows x 8 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fltr2 = (df[\"Date\"] >= \"2019\") & (df[\"Date\"] <= \"2020\") # checking records of only of 2019\n",
    "df.loc[fltr2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "# using indexes for this method\n",
    "df.set_index(\"Date\", inplace = True) # setting the Date colmn as index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Day Of Week</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-03-13 08:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-13 07:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-13 06:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-13 05:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-13 04:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-01 03:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>265.74</td>\n",
       "      <td>272.74</td>\n",
       "      <td>265.00</td>\n",
       "      <td>272.57</td>\n",
       "      <td>1500282.55</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-01 02:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>268.79</td>\n",
       "      <td>269.90</td>\n",
       "      <td>265.00</td>\n",
       "      <td>265.74</td>\n",
       "      <td>1702536.85</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-01 01:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>274.83</td>\n",
       "      <td>274.93</td>\n",
       "      <td>265.00</td>\n",
       "      <td>268.79</td>\n",
       "      <td>3010787.99</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-01 12:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>275.01</td>\n",
       "      <td>275.01</td>\n",
       "      <td>271.00</td>\n",
       "      <td>274.83</td>\n",
       "      <td>824362.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-01 11:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>279.98</td>\n",
       "      <td>279.99</td>\n",
       "      <td>272.10</td>\n",
       "      <td>275.01</td>\n",
       "      <td>679358.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23674 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2020-03-13 08:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93   \n",
       "2020-03-13 07:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09   \n",
       "2020-03-13 06:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81   \n",
       "2020-03-13 05:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92   \n",
       "2020-03-13 04:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71   \n",
       "...                     ...     ...     ...     ...     ...         ...   \n",
       "2017-07-01 03:00:00  ETHUSD  265.74  272.74  265.00  272.57  1500282.55   \n",
       "2017-07-01 02:00:00  ETHUSD  268.79  269.90  265.00  265.74  1702536.85   \n",
       "2017-07-01 01:00:00  ETHUSD  274.83  274.93  265.00  268.79  3010787.99   \n",
       "2017-07-01 12:00:00  ETHUSD  275.01  275.01  271.00  274.83   824362.87   \n",
       "2017-07-01 11:00:00  ETHUSD  279.98  279.99  272.10  275.01   679358.87   \n",
       "\n",
       "                    Day Of Week  \n",
       "Date                             \n",
       "2020-03-13 08:00:00      Friday  \n",
       "2020-03-13 07:00:00      Friday  \n",
       "2020-03-13 06:00:00      Friday  \n",
       "2020-03-13 05:00:00      Friday  \n",
       "2020-03-13 04:00:00      Friday  \n",
       "...                         ...  \n",
       "2017-07-01 03:00:00    Saturday  \n",
       "2017-07-01 02:00:00    Saturday  \n",
       "2017-07-01 01:00:00    Saturday  \n",
       "2017-07-01 12:00:00    Saturday  \n",
       "2017-07-01 11:00:00    Saturday  \n",
       "\n",
       "[23674 rows x 7 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Day Of Week</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-12-31 11:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.33</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.14</td>\n",
       "      <td>128.54</td>\n",
       "      <td>440678.91</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-12-31 10:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.38</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.95</td>\n",
       "      <td>128.33</td>\n",
       "      <td>554646.02</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-12-31 09:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.86</td>\n",
       "      <td>128.43</td>\n",
       "      <td>127.72</td>\n",
       "      <td>128.38</td>\n",
       "      <td>350155.69</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-12-31 08:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.84</td>\n",
       "      <td>128.34</td>\n",
       "      <td>127.71</td>\n",
       "      <td>127.86</td>\n",
       "      <td>428183.38</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-12-31 07:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.60</td>\n",
       "      <td>127.84</td>\n",
       "      <td>1169847.84</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-01-01 04:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.75</td>\n",
       "      <td>133.96</td>\n",
       "      <td>130.74</td>\n",
       "      <td>131.96</td>\n",
       "      <td>2791135.37</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-01-01 03:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.75</td>\n",
       "      <td>503732.63</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-01-01 02:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.88</td>\n",
       "      <td>129.55</td>\n",
       "      <td>130.06</td>\n",
       "      <td>838183.43</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-01-01 01:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.62</td>\n",
       "      <td>131.62</td>\n",
       "      <td>130.77</td>\n",
       "      <td>130.79</td>\n",
       "      <td>434917.99</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-01-01 12:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.53</td>\n",
       "      <td>131.91</td>\n",
       "      <td>130.48</td>\n",
       "      <td>131.62</td>\n",
       "      <td>1067136.21</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2019-12-31 11:00:00  ETHUSD  128.33  128.69  128.14  128.54   440678.91   \n",
       "2019-12-31 10:00:00  ETHUSD  128.38  128.69  127.95  128.33   554646.02   \n",
       "2019-12-31 09:00:00  ETHUSD  127.86  128.43  127.72  128.38   350155.69   \n",
       "2019-12-31 08:00:00  ETHUSD  127.84  128.34  127.71  127.86   428183.38   \n",
       "2019-12-31 07:00:00  ETHUSD  128.69  128.69  127.60  127.84  1169847.84   \n",
       "...                     ...     ...     ...     ...     ...         ...   \n",
       "2019-01-01 04:00:00  ETHUSD  130.75  133.96  130.74  131.96  2791135.37   \n",
       "2019-01-01 03:00:00  ETHUSD  130.06  130.79  130.06  130.75   503732.63   \n",
       "2019-01-01 02:00:00  ETHUSD  130.79  130.88  129.55  130.06   838183.43   \n",
       "2019-01-01 01:00:00  ETHUSD  131.62  131.62  130.77  130.79   434917.99   \n",
       "2019-01-01 12:00:00  ETHUSD  130.53  131.91  130.48  131.62  1067136.21   \n",
       "\n",
       "                    Day Of Week  \n",
       "Date                             \n",
       "2019-12-31 11:00:00     Tuesday  \n",
       "2019-12-31 10:00:00     Tuesday  \n",
       "2019-12-31 09:00:00     Tuesday  \n",
       "2019-12-31 08:00:00     Tuesday  \n",
       "2019-12-31 07:00:00     Tuesday  \n",
       "...                         ...  \n",
       "2019-01-01 04:00:00     Tuesday  \n",
       "2019-01-01 03:00:00     Tuesday  \n",
       "2019-01-01 02:00:00     Tuesday  \n",
       "2019-01-01 01:00:00     Tuesday  \n",
       "2019-01-01 12:00:00     Tuesday  \n",
       "\n",
       "[8760 rows x 7 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"2019\"] # getting the data for certain year as index is already set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Day Of Week</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-02-29 11:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.35</td>\n",
       "      <td>223.58</td>\n",
       "      <td>216.83</td>\n",
       "      <td>217.31</td>\n",
       "      <td>1927939.88</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-02-29 10:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.48</td>\n",
       "      <td>223.59</td>\n",
       "      <td>222.14</td>\n",
       "      <td>223.35</td>\n",
       "      <td>535998.57</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-02-29 09:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>224.63</td>\n",
       "      <td>225.14</td>\n",
       "      <td>222.74</td>\n",
       "      <td>223.48</td>\n",
       "      <td>561158.03</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-02-29 08:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.31</td>\n",
       "      <td>225.33</td>\n",
       "      <td>223.50</td>\n",
       "      <td>224.63</td>\n",
       "      <td>511648.65</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-02-29 07:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.09</td>\n",
       "      <td>225.85</td>\n",
       "      <td>223.87</td>\n",
       "      <td>225.31</td>\n",
       "      <td>1250856.20</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 04:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.57</td>\n",
       "      <td>130.00</td>\n",
       "      <td>129.50</td>\n",
       "      <td>129.56</td>\n",
       "      <td>702786.82</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 03:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.37</td>\n",
       "      <td>130.44</td>\n",
       "      <td>129.38</td>\n",
       "      <td>129.57</td>\n",
       "      <td>496704.23</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 02:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.14</td>\n",
       "      <td>130.50</td>\n",
       "      <td>129.91</td>\n",
       "      <td>130.37</td>\n",
       "      <td>396315.72</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 01:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.34</td>\n",
       "      <td>130.14</td>\n",
       "      <td>128.32</td>\n",
       "      <td>130.14</td>\n",
       "      <td>635419.40</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 12:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.12</td>\n",
       "      <td>128.34</td>\n",
       "      <td>245119.91</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1440 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2020-02-29 11:00:00  ETHUSD  223.35  223.58  216.83  217.31  1927939.88   \n",
       "2020-02-29 10:00:00  ETHUSD  223.48  223.59  222.14  223.35   535998.57   \n",
       "2020-02-29 09:00:00  ETHUSD  224.63  225.14  222.74  223.48   561158.03   \n",
       "2020-02-29 08:00:00  ETHUSD  225.31  225.33  223.50  224.63   511648.65   \n",
       "2020-02-29 07:00:00  ETHUSD  225.09  225.85  223.87  225.31  1250856.20   \n",
       "...                     ...     ...     ...     ...     ...         ...   \n",
       "2020-01-01 04:00:00  ETHUSD  129.57  130.00  129.50  129.56   702786.82   \n",
       "2020-01-01 03:00:00  ETHUSD  130.37  130.44  129.38  129.57   496704.23   \n",
       "2020-01-01 02:00:00  ETHUSD  130.14  130.50  129.91  130.37   396315.72   \n",
       "2020-01-01 01:00:00  ETHUSD  128.34  130.14  128.32  130.14   635419.40   \n",
       "2020-01-01 12:00:00  ETHUSD  128.54  128.54  128.12  128.34   245119.91   \n",
       "\n",
       "                    Day Of Week  \n",
       "Date                             \n",
       "2020-02-29 11:00:00    Saturday  \n",
       "2020-02-29 10:00:00    Saturday  \n",
       "2020-02-29 09:00:00    Saturday  \n",
       "2020-02-29 08:00:00    Saturday  \n",
       "2020-02-29 07:00:00    Saturday  \n",
       "...                         ...  \n",
       "2020-01-01 04:00:00   Wednesday  \n",
       "2020-01-01 03:00:00   Wednesday  \n",
       "2020-01-01 02:00:00   Wednesday  \n",
       "2020-01-01 01:00:00   Wednesday  \n",
       "2020-01-01 12:00:00   Wednesday  \n",
       "\n",
       "[1440 rows x 7 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# using slice method to get data of certain months\n",
    "df[\"2020-01\" : \"2020-02\"] # getting data from jan to feb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2020-02-29 11:00:00    217.31\n",
       "2020-02-29 10:00:00    223.35\n",
       "2020-02-29 09:00:00    223.48\n",
       "2020-02-29 08:00:00    224.63\n",
       "2020-02-29 07:00:00    225.31\n",
       "                        ...  \n",
       "2020-01-01 04:00:00    129.56\n",
       "2020-01-01 03:00:00    129.57\n",
       "2020-01-01 02:00:00    130.37\n",
       "2020-01-01 01:00:00    130.14\n",
       "2020-01-01 12:00:00    128.34\n",
       "Name: Close, Length: 1440, dtype: float64"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"2020-01\" : \"2020-02\"][\"Close\"] # accessing a certain column of the certain range of months"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "195.1655902777778"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"2020-01\" : \"2020-02\"][\"Close\"].mean() # getting the mean of it"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    1440.000000\n",
       "mean      195.165590\n",
       "std        47.896863\n",
       "min       125.630000\n",
       "25%       160.135000\n",
       "50%       179.145000\n",
       "75%       233.657500\n",
       "max       286.390000\n",
       "Name: Close, dtype: float64"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"2020-01\" : \"2020-02\"][\"Close\"].describe() # getting statistics data of it"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Day Of Week</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-01-01 11:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.77</td>\n",
       "      <td>130.27</td>\n",
       "      <td>129.24</td>\n",
       "      <td>130.19</td>\n",
       "      <td>215362.64</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 10:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.41</td>\n",
       "      <td>131.41</td>\n",
       "      <td>129.36</td>\n",
       "      <td>129.77</td>\n",
       "      <td>411940.73</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 09:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.73</td>\n",
       "      <td>131.99</td>\n",
       "      <td>130.97</td>\n",
       "      <td>131.41</td>\n",
       "      <td>1168999.08</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 08:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.34</td>\n",
       "      <td>131.87</td>\n",
       "      <td>131.23</td>\n",
       "      <td>131.73</td>\n",
       "      <td>162346.84</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 07:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.64</td>\n",
       "      <td>131.72</td>\n",
       "      <td>131.15</td>\n",
       "      <td>131.34</td>\n",
       "      <td>167992.84</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 06:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.97</td>\n",
       "      <td>132.14</td>\n",
       "      <td>131.24</td>\n",
       "      <td>131.64</td>\n",
       "      <td>266693.21</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 05:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>132.55</td>\n",
       "      <td>132.68</td>\n",
       "      <td>131.94</td>\n",
       "      <td>131.97</td>\n",
       "      <td>244271.72</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 04:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.75</td>\n",
       "      <td>132.56</td>\n",
       "      <td>131.51</td>\n",
       "      <td>132.55</td>\n",
       "      <td>270425.94</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 03:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.66</td>\n",
       "      <td>132.15</td>\n",
       "      <td>131.29</td>\n",
       "      <td>131.75</td>\n",
       "      <td>168230.71</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 02:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.41</td>\n",
       "      <td>132.05</td>\n",
       "      <td>130.93</td>\n",
       "      <td>131.66</td>\n",
       "      <td>143192.12</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 01:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.28</td>\n",
       "      <td>132.08</td>\n",
       "      <td>131.04</td>\n",
       "      <td>131.41</td>\n",
       "      <td>569499.97</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 12:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.36</td>\n",
       "      <td>131.31</td>\n",
       "      <td>130.36</td>\n",
       "      <td>131.28</td>\n",
       "      <td>221073.63</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 11:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.33</td>\n",
       "      <td>131.42</td>\n",
       "      <td>130.23</td>\n",
       "      <td>130.36</td>\n",
       "      <td>243130.52</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 10:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.98</td>\n",
       "      <td>130.33</td>\n",
       "      <td>129.88</td>\n",
       "      <td>130.33</td>\n",
       "      <td>73422.13</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 09:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.01</td>\n",
       "      <td>130.22</td>\n",
       "      <td>129.96</td>\n",
       "      <td>129.98</td>\n",
       "      <td>108011.54</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 08:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.87</td>\n",
       "      <td>130.01</td>\n",
       "      <td>129.61</td>\n",
       "      <td>130.01</td>\n",
       "      <td>134231.17</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 07:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.00</td>\n",
       "      <td>130.25</td>\n",
       "      <td>129.80</td>\n",
       "      <td>129.87</td>\n",
       "      <td>112620.14</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 06:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.83</td>\n",
       "      <td>130.25</td>\n",
       "      <td>129.82</td>\n",
       "      <td>130.00</td>\n",
       "      <td>118328.64</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 05:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.56</td>\n",
       "      <td>129.94</td>\n",
       "      <td>129.47</td>\n",
       "      <td>129.83</td>\n",
       "      <td>232163.70</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 04:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.57</td>\n",
       "      <td>130.00</td>\n",
       "      <td>129.50</td>\n",
       "      <td>129.56</td>\n",
       "      <td>702786.82</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 03:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.37</td>\n",
       "      <td>130.44</td>\n",
       "      <td>129.38</td>\n",
       "      <td>129.57</td>\n",
       "      <td>496704.23</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 02:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.14</td>\n",
       "      <td>130.50</td>\n",
       "      <td>129.91</td>\n",
       "      <td>130.37</td>\n",
       "      <td>396315.72</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 01:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.34</td>\n",
       "      <td>130.14</td>\n",
       "      <td>128.32</td>\n",
       "      <td>130.14</td>\n",
       "      <td>635419.40</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-01 12:00:00</th>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.12</td>\n",
       "      <td>128.34</td>\n",
       "      <td>245119.91</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2020-01-01 11:00:00  ETHUSD  129.77  130.27  129.24  130.19   215362.64   \n",
       "2020-01-01 10:00:00  ETHUSD  131.41  131.41  129.36  129.77   411940.73   \n",
       "2020-01-01 09:00:00  ETHUSD  131.73  131.99  130.97  131.41  1168999.08   \n",
       "2020-01-01 08:00:00  ETHUSD  131.34  131.87  131.23  131.73   162346.84   \n",
       "2020-01-01 07:00:00  ETHUSD  131.64  131.72  131.15  131.34   167992.84   \n",
       "2020-01-01 06:00:00  ETHUSD  131.97  132.14  131.24  131.64   266693.21   \n",
       "2020-01-01 05:00:00  ETHUSD  132.55  132.68  131.94  131.97   244271.72   \n",
       "2020-01-01 04:00:00  ETHUSD  131.75  132.56  131.51  132.55   270425.94   \n",
       "2020-01-01 03:00:00  ETHUSD  131.66  132.15  131.29  131.75   168230.71   \n",
       "2020-01-01 02:00:00  ETHUSD  131.41  132.05  130.93  131.66   143192.12   \n",
       "2020-01-01 01:00:00  ETHUSD  131.28  132.08  131.04  131.41   569499.97   \n",
       "2020-01-01 12:00:00  ETHUSD  130.36  131.31  130.36  131.28   221073.63   \n",
       "2020-01-01 11:00:00  ETHUSD  130.33  131.42  130.23  130.36   243130.52   \n",
       "2020-01-01 10:00:00  ETHUSD  129.98  130.33  129.88  130.33    73422.13   \n",
       "2020-01-01 09:00:00  ETHUSD  130.01  130.22  129.96  129.98   108011.54   \n",
       "2020-01-01 08:00:00  ETHUSD  129.87  130.01  129.61  130.01   134231.17   \n",
       "2020-01-01 07:00:00  ETHUSD  130.00  130.25  129.80  129.87   112620.14   \n",
       "2020-01-01 06:00:00  ETHUSD  129.83  130.25  129.82  130.00   118328.64   \n",
       "2020-01-01 05:00:00  ETHUSD  129.56  129.94  129.47  129.83   232163.70   \n",
       "2020-01-01 04:00:00  ETHUSD  129.57  130.00  129.50  129.56   702786.82   \n",
       "2020-01-01 03:00:00  ETHUSD  130.37  130.44  129.38  129.57   496704.23   \n",
       "2020-01-01 02:00:00  ETHUSD  130.14  130.50  129.91  130.37   396315.72   \n",
       "2020-01-01 01:00:00  ETHUSD  128.34  130.14  128.32  130.14   635419.40   \n",
       "2020-01-01 12:00:00  ETHUSD  128.54  128.54  128.12  128.34   245119.91   \n",
       "\n",
       "                    Day Of Week  \n",
       "Date                             \n",
       "2020-01-01 11:00:00   Wednesday  \n",
       "2020-01-01 10:00:00   Wednesday  \n",
       "2020-01-01 09:00:00   Wednesday  \n",
       "2020-01-01 08:00:00   Wednesday  \n",
       "2020-01-01 07:00:00   Wednesday  \n",
       "2020-01-01 06:00:00   Wednesday  \n",
       "2020-01-01 05:00:00   Wednesday  \n",
       "2020-01-01 04:00:00   Wednesday  \n",
       "2020-01-01 03:00:00   Wednesday  \n",
       "2020-01-01 02:00:00   Wednesday  \n",
       "2020-01-01 01:00:00   Wednesday  \n",
       "2020-01-01 12:00:00   Wednesday  \n",
       "2020-01-01 11:00:00   Wednesday  \n",
       "2020-01-01 10:00:00   Wednesday  \n",
       "2020-01-01 09:00:00   Wednesday  \n",
       "2020-01-01 08:00:00   Wednesday  \n",
       "2020-01-01 07:00:00   Wednesday  \n",
       "2020-01-01 06:00:00   Wednesday  \n",
       "2020-01-01 05:00:00   Wednesday  \n",
       "2020-01-01 04:00:00   Wednesday  \n",
       "2020-01-01 03:00:00   Wednesday  \n",
       "2020-01-01 02:00:00   Wednesday  \n",
       "2020-01-01 01:00:00   Wednesday  \n",
       "2020-01-01 12:00:00   Wednesday  "
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"2020-01-01\"].head(24)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2020-01-01 11:00:00    130.27\n",
       "2020-01-01 10:00:00    131.41\n",
       "2020-01-01 09:00:00    131.99\n",
       "2020-01-01 08:00:00    131.87\n",
       "2020-01-01 07:00:00    131.72\n",
       "2020-01-01 06:00:00    132.14\n",
       "2020-01-01 05:00:00    132.68\n",
       "2020-01-01 04:00:00    132.56\n",
       "2020-01-01 03:00:00    132.15\n",
       "2020-01-01 02:00:00    132.05\n",
       "2020-01-01 01:00:00    132.08\n",
       "2020-01-01 12:00:00    131.31\n",
       "2020-01-01 11:00:00    131.42\n",
       "2020-01-01 10:00:00    130.33\n",
       "2020-01-01 09:00:00    130.22\n",
       "2020-01-01 08:00:00    130.01\n",
       "2020-01-01 07:00:00    130.25\n",
       "2020-01-01 06:00:00    130.25\n",
       "2020-01-01 05:00:00    129.94\n",
       "2020-01-01 04:00:00    130.00\n",
       "2020-01-01 03:00:00    130.44\n",
       "2020-01-01 02:00:00    130.50\n",
       "2020-01-01 01:00:00    130.14\n",
       "2020-01-01 12:00:00    128.54\n",
       "Name: High, dtype: float64"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"2020-01-01\"][\"High\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "132.68"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"2020-01-01\"][\"High\"].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2017-07-01    279.99\n",
       "2017-07-02    293.73\n",
       "2017-07-03    285.00\n",
       "2017-07-04    282.83\n",
       "2017-07-05    274.97\n",
       "               ...  \n",
       "2020-03-09    208.65\n",
       "2020-03-10    206.28\n",
       "2020-03-11    202.98\n",
       "2020-03-12    195.64\n",
       "2020-03-13    148.00\n",
       "Freq: D, Name: High, Length: 987, dtype: float64"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# getting the daily max values\n",
    "df[\"High\"].resample(\"D\").max() # resampling the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "dailymax = df[\"High\"].resample(\"D\").max() # saving in variable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2017-07-01    279.99\n",
       "2017-07-02    293.73\n",
       "2017-07-03    285.00\n",
       "2017-07-04    282.83\n",
       "2017-07-05    274.97\n",
       "               ...  \n",
       "2020-03-09    208.65\n",
       "2020-03-10    206.28\n",
       "2020-03-11    202.98\n",
       "2020-03-12    195.64\n",
       "2020-03-13    148.00\n",
       "Freq: D, Name: High, Length: 987, dtype: float64"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dailymax"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "132.68"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dailymax[\"2020-01-01\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1b3b3a2c8e0>"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAESCAYAAAAR2wXeAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3dd3yb1bnA8d8jyXs7cZzh7D0hJIQEaBhhQwkU2kuBQoE2LaUtpe2lpJTSAS2XUm4vl1VKKaNcNpRQIBACYQZC9h7OdpbtOIn3kHTuH+8rWbZlW7JkS7af7+fDx9J5X7064nUeH53xHDHGoJRSqndwxLoCSimluo4GfaWU6kU06CulVC+iQV8ppXoRDfpKKdWLaNBXSqlexBXrCrSnb9++ZtiwYbGuhlJKdSsrVqwoNcbkNS+P+6A/bNgwli9fHutqKKVUtyIiu4OVa/eOUkr1Ihr0lVKqF9Ggr5RSvYgGfaWU6kU06CulVC+iQV8ppXoRDfrdgDEGj1dTYCulItdu0BeRJ0SkWETWBzn2cxExItI3oGy+iBSKyBYROTegfJqIrLOPPSAiEr2P0bPds3AzI3/5Fl4N/EqpCIXS0n8SOK95oYgMBs4G9gSUTQCuACbar3lYRJz24UeAecBo+78W11TBPbPUWmNRUeuOcU2UUt1du0HfGPMRUBbk0H8DtwKBzc+5wPPGmDpjzE6gEJghIgOATGPMUmNt1fU0cEnEte8lMpKthdNl1fUxrolSqrvrUJ++iFwM7DPGrGl2aBCwN+B5kV02yH7cvFyFID3JCvpHNOgrpSIUdu4dEUkFbgfOCXY4SJlpo7y195iH1RXEkCFDwq1ij1Lv9lLv8QJwVIO+UipCHWnpjwSGA2tEZBdQAKwUkf5YLfjBAecWAPvt8oIg5UEZYx4zxkw3xkzPy2uRJK5Xufn5VewtqwGgsLgyxrVRSnV3YQd9Y8w6Y0w/Y8wwY8wwrIB+gjHmILAAuEJEkkRkONaA7TJjzAGgQkRm2rN2rgFej97H6LneXn/Q/3jVnqMxrIlSqicIZcrmc8BSYKyIFInIDa2da4zZALwIbAQWAjcZYzz24RuBx7EGd7cDb0dY916ntsHT/klKKdWGdvv0jTHfbOf4sGbP7wbuDnLecmBSmPXr9UTA2KMfDR6dp6+UioyuyI1zLkfjGLhvQFcppTpKg36cczkab1GDBn2lVIQ06Me5Ji19twZ9pVRkNOjHOaezMehrS18pFSkN+nEusKWvA7lKqUhp0I9zTu3eUUpFkQb9OBc4kKuzd5RSkdKgH+ecDu3TV0pFjwb9OOc1jf342r2jlIqUBv04FxjotaWvlIqUBv04F9iP3+AxGKMzeJRSHadBP84179LRaZtKqUho0I9zdW4vF04ewA2nDgd0Bo9SKjJh75yluo7b48XjNYzJzyAzxbpVDW4vJMW4Ykqpbktb+nHM16pPSnCQ6LJulQ7mKqUioUE/jvn68xOdDhKc1q2q02mbSqkIaNCPY74An5TgINGpLX2lVOQ06MexwJZ+Y/eOzt5RSnWcBv041tjSd/q7d7Slr5SKhAb9OFbntjZCt/r0xS7ztjiulFKh0qAfx3xdOYkuadGn/86Gg4z91UKW7SyLWf2UUt1Pu0FfRJ4QkWIRWR9Q9icR2Swia0XkNRHJDjg2X0QKRWSLiJwbUD5NRNbZxx4QEWn+Xqoptx3gE5wtp2xuPVgBwPubi2NTOaVUtxRKS/9J4LxmZYuAScaYKcBWYD6AiEwArgAm2q95WESc9mseAeYBo+3/ml9TNeObp+9yNE7ZrA+Y0QPax6+UCk+7Qd8Y8xFQ1qzsXWOM2376OVBgP54LPG+MqTPG7AQKgRkiMgDINMYsNVbGsKeBS6L1IXoqt929k+CUFgO5bq9p8lwppUIRjT7964G37ceDgL0Bx4rsskH24+blQYnIPBFZLiLLS0pKolDF7sntDezesXrD6u0/BL4/CJpjXykVjoiCvojcDriBZ31FQU4zbZQHZYx5zBgz3RgzPS8vL5Iqdmv1but/kcspJDqddpkV5H0t/NoGncGjlApdhxOuici1wEXAHNOY5L0IGBxwWgGw3y4vCFKu2hDY0k+wW/q+YO/r76+q16CvlApdh1r6InIe8AvgYmNMdcChBcAVIpIkIsOxBmyXGWMOABUiMtOetXMN8HqEde/xGgJm77To07e7d2o06CulwhDKlM3ngKXAWBEpEpEbgAeBDGCRiKwWkUcBjDEbgBeBjcBC4CZjjC8q3Qg8jjW4u53GcQDVCt88fZejcSB36fbDNHi8/uBfVe9u9fVKKdVcu907xphvBin+exvn3w3cHaR8OTAprNr1co2zdxwk2fP0315/kDv+tR7fMofqOm3pK6VCpyty41hj905jSx/g3Y2H/MeqG7Slr5QKnQb9OOYL7C6nA6ejcQJUWVW9/9ix6gbdLF0pFTIN+nHMtwDLl2ytyTG766e81s3DS7Z3ab2UUt2XBv041uBunL3TXOAG6a+sLGpxXCmlgtGgH8cavI2zd5pzBwT9tETd314pFRoN+nHM7fHicgjBEpIG7qCVnqRBXykVGg36cazB4w3atQPWBiqj+qUDcNzg7KDnKKVUcxr041iDx+AKMogLUFXnYVifVJITHHh19o5SKkQa9OOY29t6S3/jgXLSklwkOByaXlkpFTIN+nGswW2CTtf0Kamow+UU//RNpZRqjwb9ONbg9eJyNN6i135wcpPjxlgLt3zZOJVSqj0a9OOY22P8e+MCTB2Sw68vmuB/Xu/xkuCQJjN5lFKqLRr041iDPWUzUHKC0/+4pt6D0yl4vBr0lVKh0aAfx6zZO01vUVJAy/8X54/TgVylVFg06Mcxt9dLojN4Sz89ycVpY/J0IFcpFRYN+nGsweNt0dJPTrCe+/r6XQ4dyFVKhU6Dfhxr8JhW+/R95S6nDuQqpUKnQT+OuT3eJrN3oLGl71u05XLoQK5SKnQa9ONYsJZ+kstq6fu7d5w6kKuUCp0G/TgWrE/ft4OW749BglP8m60opVR72g36IvKEiBSLyPqAslwRWSQi2+yfOQHH5otIoYhsEZFzA8qnicg6+9gDEixfsGqitLKOxGZB39eVk5Lo69vXlr5SKnShtPSfBM5rVnYbsNgYMxpYbD9HRCYAVwAT7dc8LCK+1USPAPOA0fZ/za+pAmzcX05pZT1vrjvQpHz8gEyunTWU//3mVACyUxM4Wt0QiyoqpbqhdoO+MeYjoKxZ8VzgKfvxU8AlAeXPG2PqjDE7gUJghogMADKNMUuNtYv30wGvUUEUllQCMLRPapNyp0P47dxJDO2TBkDf9CRKK+u6vH5Kqe6po336+caYAwD2z352+SBgb8B5RXbZIPtx83LViuLyWgBe+t6sNs/rm55Edb2Hqjp3V1RLKdXNRXsgN1g/vWmjPPhFROaJyHIRWV5SUhK1ynUnh8prSU5wkJeR1OZ5vuPa2ldKhaKjQf+Q3WWD/bPYLi8CBgecVwDst8sLgpQHZYx5zBgz3RgzPS8vr4NV7N4qat1kJicE3R83UN/0RMDKre/j9nh5e90BvDqrRynVTEeD/gLgWvvxtcDrAeVXiEiSiAzHGrBdZncBVYjITHvWzjUBr1FBVNa5Q9rwPFhL/0/vbOHGZ1fySWFpp9VPKdU9tRtVROQ54HSgr4gUAXcC9wAvisgNwB7g6wDGmA0i8iKwEXADNxljPPalbsSaCZQCvG3/p1pRVecmLZSgn24F/cCW/sfbrGBfUav9/EqpptqNKsaYb7ZyaE4r598N3B2kfDkwKaza9WJVdR7SkpztnpeVmgDAsZrGaZu+BVxlVdrPr5RqSlfkxqlQu3d8i7cCk675hgHueH1Dp9RNKdV9adCPU1X1oXXviAhOh/jTK3u9hrVFxzq7ekqpbkqDfpyqrveQmth+0AcrD49vI5UPtzZOcXU6BGstnFJKWTTox6naBo8/jXJ7EpwO6u38O/uO1gAwcWAmHq+hzq15eZRSjTTox6k6t9efRrk9CQFbJpZW1iECl51gLYvQGTxKqUAa9OOQMYZ6t7fJJuhtcTkbt0wsrqgjNzWRbHtWj6ZnUEoF0qAfh3xdMr6tEduT4GjcMrG8poGs1AT/IHClBn2lVAAN+nHIF/TDaul7vHxWWErRkRpSEpz+6Z4a9JVSgUKbHqK6VF2DtYg5KcSBXJdTqG3wcuXjXwAwfWiOP+hr945SKpC29ONQY0s/tO6dRKeDwwGrb1MSnU26dwqLK3XqplIK0KAfl+rcdks/5O4dobSy3v88sHvnw60lnHX/h/zz893Rr6hSqtvRoB+HahvCG8h1ORyUVjRt6acnW0H/1ZX7AHhh+d6gr1VK9S4a9OPAZ4WlTVIj+7p3EkNs6Sc4hYqAvvuUBCepzf5gFB2p0Q3UlVIa9GPNGMOVj3/BNx5d6i+r9wV9Z+grcgN9tLUEh6Pp5itHqxt4eql28SjV22nQjzHf/PodpVX+Mt9CqwRn27tm+TibBfhTRvUF4MIpA/xlkwZl8vt/b2TZzuZ73CulehMN+jHmG7QN5Eup4Aqxpe9tNjPnnsumAHCv/RPg7ksmA7B675EO1VMp1TNo0I+xYAnRfH3vLkdoLX1vs0v4Wv6BqZmPG5xNTmoCO0urO1hTpVRPoIuzYqw+IOjvP1rDwOwUf5dP87761jgCTnv5+7OaHLvixMGcOCwXgEE5KRw4VhNhjZVS3ZkG/RgLbOlvOVjBwOwUf5++K8Q+fcE6b9KgTKbbAd7nnoAunr7pSU1mCSmleh/t3omxJn36doz3t/Qdod0e3/aIN88Z0+Z5eelJlFbUt3lOOOrcHu57ZwsHj9VG7ZpKqc6lQT/GArt3fHly3J4wW/p21G9vDKBvhtXSj1ZKhsc/3smDHxTyki78UqrbiCjoi8gtIrJBRNaLyHMikiwiuSKySES22T9zAs6fLyKFIrJFRM6NvPrdX12QoN/gDa9P3xfqDW0H88zkBNxe41/xG6k9h61B4VAXkSmlYq/D/1pFZBDwY2C6MWYS4ASuAG4DFhtjRgOL7eeIyAT7+ETgPOBhEQktz0APVhcQgCvrrK4eX0s/1Hn6vgZ+81k8zaUnOe33iU7mzaM1VleR7s6lVPcRaRPNBaSIiAtIBfYDc4Gn7ONPAZfYj+cCzxtj6owxO4FCYEaE79/tBfbp+1v6/u6d0G7PVScNBWDSoKw2z0uLcrrlA3ZffkVtQ1Sup5TqfB0O+saYfcB9wB7gAHDMGPMukG+MOWCfcwDoZ79kEBDY+Vtkl7UgIvNEZLmILC8pKeloFbuFwO6d8horePoGckOdp3/WhHx23XMh/bOS2zwv2rtp7T9qB33N2a9UtxFJ904OVut9ODAQSBORq9t6SZCyoJ3QxpjHjDHTjTHT8/LyOlrFuOf1GqrrG1v6h6us7hJ3mPP0Q5WWGL2Wfp3b45/+WV6jQV+p7iKSefpnATuNMSUAIvIqcDJwSEQGGGMOiMgAoNg+vwgYHPD6AqzuoF7J7fEy6va3ybRTIA/OTfEHUbfXi0jLnDqRSrP79KvqIw/SxeWN8/33HdUFX0p1F5E0JfcAM0UkVaw5g3OATcAC4Fr7nGuB1+3HC4ArRCRJRIYDo4FlEbx/t1Zjb4lYbg+CDs1No6SiDq/X0OAxIc/RD0fjFoot8/2Ey1f/AVnJ7CqtwuvVnbmU6g4i6dP/AngZWAmss6/1GHAPcLaIbAPOtp9jjNkAvAhsBBYCNxljIo8+3VTznDsDs5PZfLCCGX94j6o6d8hz9MMRzYFc3/qCsf0zqGnw8NIKnauvVHcQUXPSGHOnMWacMWaSMeZb9sycw8aYOcaY0fbPsoDz7zbGjDTGjDXGvB159buv2obGv3epiU4ykxMAKK2sZ+mOwyFvlRiOaA7k+mYYjc3PAOAXr6yL+JpKqc6nq2piJLClnxqwvSFAYXElQ/qkRf090xLtPv0odO/4WvoTBmZGfC2lVNfRoB8jgYuyUhKdNM+MUJCTEvX39M37/+/3tkacisE3rXRgdgrnTezPwKxk9uuArlJxT4N+jAQuyspNTaS22WYqt547tlPff/XeoxG9vsG/athB/6xk9h+r5eR73teZPErFOQ36MRKY/2b8gEwa3FbLeVB2Ci9/fxZDO6F7J9ClD38W0evrA1JFZAZ0TS3ZUtzaS5RScUDz6cdIYEt/WN80vnbCIA5V1HLP1yaTYQ/qdoaLjxvIgjX7Ix4oDty8PbC+hzTNslJxTVv6MRI4kJuW5KJfRjIPXXlCpwZ8gAe+OZXLTiggNy0xousEdu9kpjS2Hd5Ye4A5f16im7UoFac06MdI4JTN5C5OTdw3I5HDlfUdGswts1NF+IJ+oqtpS39naRXbS6p4Y02vXWytVFzToB8jvtkvAMkJXZthuiA7hXqP158lM1RbD1Vwwu8X8dyyPdQH5AfKDPLtZFdpVVTqqpSKLg36MRKYtmDqkOwufe/JBdb7rS06FtbrSiusLpuHlxRSZ39TSXQ6/Dl9Au09orN4lIpHGvRjxGN3rSydfyYFOald+t75mUkAHKkOb79c345ee8tquOvNTQAkuASXnScoK6WxxR/utwilVNfQ2Tsx4rEDqFOin2OnPUkuq2Ve7w5v28TAcQifBKeDwbnWQrJfnDeOHSWVfLb9cNRy9iulokuDfox47Za+I8rpk0Ph29M2WkE/OzWRXfdc6C+7/bV1LFx/MLJKKqU6hXbvxEgsW/qJdjqGOnd4OXiCBf1g0pNc2tJXKk5pSz9GfEE/Fi1934br4bf0G8//w6WTGdon+FhEWpKLOreXBo836rt/KaUio0E/RnzdO9HeHSsUIkKiy0Gdp2PdO7PH5HHlSUNaPS8wb392amSLwJRS0aXNsBjxxdtYdO8AJLkcYbf0fbtl/ePbJ7Z5Xro9hVO7eJSKPxr0Y6RxIDc275/kcrTYvas9FbVuEpzS7reT9CRr6mY08vYrpaJLg36MxHIgF6zB3HBb+os3HeK4gvYXkqVpS1+puKVBP0b8QT8GffpgTdsMJ+i7PV72lFUza2Sfds9Nj+JevEqp6NKgHyNeYxCxBlVjYf+xWhas2R9y0rUDx2rxGivff3uab8D+8ooirn/yS/0joFQciCjoi0i2iLwsIptFZJOIzBKRXBFZJCLb7J85AefPF5FCEdkiIudGXv3uy+M1MevagcbpmvtDTJfwxlora+ZoeyP0tvha+keqGwD420c7eH9zMZ/vONyRqiqloijSlv7/AAuNMeOA44BNwG3AYmPMaGCx/RwRmQBcAUwEzgMeFpGuTS8ZRzxeE5M5+j7fP20kALsPh5YNc29ZNdmpCUwbmtPuub6W/i9fWweAwfo2ccNTyyksruhIdZVSUdLhoC8imcBs4O8Axph6Y8xRYC7wlH3aU8Al9uO5wPPGmDpjzE6gEJjR0ffv7mLd0r/Knme/t6w6pPOr6jzkhDjn3tfSB6iobcAdkFH0q//7aRi1VEpFWyQt/RFACfAPEVklIo+LSBqQb4w5AGD/7GefPwjYG/D6IrusV/IYE7NBXMC/c9ZRuwumPdX1blITQ/tiluhy8MMzRgGw5WAFZVX1XD1zCH3SEqlp8FBTr1M5lYqVSIK+CzgBeMQYMxWowu7KaUWwCBd0FFFE5onIchFZXlJSEkEV45fXa4hhzCc10YnTIRQdqeFYCIG/ss7t77YJxeXTCgBYtquMo9UNDM5J5feXTAJge0llxyqtlIpYJEG/CCgyxnxhP38Z64/AIREZAGD/LA44f3DA6wuAoHvqGWMeM8ZMN8ZMz8vLi6CK8SvWLX0RISslgWc+381xv3u33fOr6z2khdjSByjIScHlEO5duAWAiQOz/Hn8D1eFl8dfKRU9HQ76xpiDwF4RGWsXzQE2AguAa+2ya4HX7ccLgCtEJElEhgOjgWUdff/uzuON3Rx9n8zkxpa7u508PFV1blLDaOm7nA4y7U1VJg/KYtbIPv5tIWvqdeqmUrESacK1HwHPikgisAO4DusPyYsicgOwB/g6gDFmg4i8iPWHwQ3cZIzptZ27Xm9sW/qAPygDHKqoa3MOflVdeC19gOyUBMqq6rn1vLE4HUJqovXrVhNiimalVPRFFPSNMauB6UEOzWnl/LuBuyN5z57CY2I7ewdosqF5eU1D20G/Prw+fYBHvzWNV1fuY8bwXABS/C398NI/KKWiR1Mrx4g3xvP0AfqmN07BLK9pfTDXGGP36Yf36zImP4Pbzh/nf55if1Oo1u4dpWJG0zDESKwHcgFuv3AC18waCsCxNoJ+nduLx2tITYpsLZ2vpR/qDlxKqejToB8jsV6cBZCXkcR3Th0BwAPvb2v1PF/OnHBb+s0luhy4HEJNg4fiilqG3fYmv/rXuoiuqZQKjwb9GDDGUFnnjnn3DkAfu4tn/b7yVpOvvbpyH0DYffrBuL2Ghz7Yzpq9xwD45+d7tOWvVBfSoB8DT362iyVbSiipqIt1VUhLcnHLWWOA4MnXFq4/wN1vbbLODXP2Tlt2BCzQ2n+0JmrXVUq1TYN+DLy59gDQdj96VzpznJUpY+XuIy2Off+fK/2Pw5mn35qfnDUagD++vdlftveIBn2luooG/S7y7oaDfLjVSikR4678Fsb0TwdgV2nTjJvNN1mZPCgr4vfqk9YyaduRNlboer2G9fuORfy+SimLBv0uMu+ZFVz7hLUAOVYbp7QmyeUkPcnlz3/vE/hN5KP/PMOfpC1aslOtdQIVbWyu8usF67nofz9hZ2loKaCVUm3ToB8DvpAfB+O4ftmpCRypbtriPlZjPb/ixMEM6ZMalfep9zQOFvtmA7W1o9YLX1qJWUsrYz/+oVRPoEE/Bhx2S9/ljJ///blpiS2Cvi/t8gWTB0TtfaYUNHYR/fzcMTgEKmubBv2aeo9/AZdvL+G2uoCUUqHTFbld4JUVRU2eO+xYnxhHQT87NbFFYK2wg3F6cvR+TU4clsvKO84mJcFJSqKTX7++gcpmLf2LH/yE0so6Vv36HHz7rxyNk0Fvpbq7+Ik6PVRhcSU/e2mN//nLK4rwTYfvn5Uco1q1lJua0KJP35cYLdTNU0J+r7REf0qG9CSXv3vn9dX7mPXHxWwrruRIdUOTKa27D1fx69fX83KzP6BKqfBoS7+TfVpY2uT5z19aw5Bcq3/8qevjZ7fIYC1936KpZFfnbWWcm5bIlkMVGGP4r7c3cyBgrUDgrJ3/+2KP/UdpN5dOHRTzFBZKdVfa0u9kvgHIwORme8qqOWVUnzazWna13LREKurcNATk1a9tsB778uB3hm/NHMraomN8UljaYoXy8t1l/seB30J+9a91/r5+pVR4NOh3sqo6DxlJLu69fEqT8uwQNxnvKjn29MnAwVxf905KJwb9i48fCMDH20opOlLD9acM5/2fnYZDYMP+cqBxamf/zGRmDM/luWV7+XzH4U6rk1I9mXbvdLLqejepSU7OHJfP5/Pn8M6Gg9y5YEPcbQ7eL9MaXzh4rJZ+GdZjX/dOUkLntQ1SE10Mzk3hsY92AFBR28CIvHT6pCex9WAFAA9feQIj+6WTm5ZIdZ2H4373LmuKjnLKqL6dVi+leipt6XeyqoA89P2zkpkwMBOAQ+Ut89zE0lB7Hv7uw9X+sroGDyKQ5OrcX5Mx/TL8j8+akA9AXnqSPxfQgOwU8jOTSXA6yEpNID8ziR0lulhLqY7QoN/JquvcTfLQj8m3AtxlJxTEqkpBDc6xgn5RQB6cWreXJJej01cQj7b/n2QkuTh3Yn+7LN1/vCCn6dhH/8zkuPujqVR3oUG/k1XVu/17wwJkpSRQePf5XHfKsNhVKojURCdOh/DxthJ/WW2Dp1P7832unDEEl0P8rXyA+eePByA5wUFCs/UM+Rr0leow7dPvZFV1HvIykpqUxdNKXB8RweM1fLb9MBv2HyMt0cXTS3fj6oKpkUP6pLLhd+f6VyqD1RX2zk9mt0j6BjAoJ4WPt5VaG9Ho1E2lwhJ/0aeHsVr6nd9ajqZ3Nhzi6aW7AWvTk66Q5HK2aNGP7Z/B5IKWmT2nFGRR0+Bh04HyLqmbUj1JxEFfRJwiskpE/m0/zxWRRSKyzf6ZE3DufBEpFJEtInJupO/dHVTXhb+heKw9sHgbb68/EOtqtOrUUXkkJzj4wbMrdb6+UmGKRkv/ZmBTwPPbgMXGmNHAYvs5IjIBuAKYCJwHPCwi3asJ3AFV9e6INxSPBd/K2H//6NQY16SlvIwk7rhoAnvKqrnp2ZXtv0Ap5RdR0BeRAuBC4PGA4rnAU/bjp4BLAsqfN8bUGWN2AoVA/OQh6ATGGKrru09L/w+XTm7yvG96EpOisHFKZ/jmiUM4Y2we72061OrevkqpliJt6f8FuBUIHG3LN8YcALB/9rPLBwF7A84rssu6jDGGP761iWU7y9o/OQrq3F48XtNtWvpfn950GumIvLQY1aR9Dodwyqi+uL2G8trW8/ErpZrqcNAXkYuAYmPMilBfEqQsaBNNROaJyHIRWV5SUhLslA752Ytr+OtHO/jGX5dG7ZptqbZX3XaXln6C00FGwD64J4/sE8PatC/HTmWhufaVCl0kLf1TgItFZBfwPHCmiPwTOCQiAwDsn8X2+UXA4IDXFwD7g13YGPOYMWa6MWZ6Xl5eBFVs6osuauH7+FIGp0VhQ/Gu8tn8MzlucDZA3Kc58G3fWFatQV+pUHU46Btj5htjCowxw7AGaN83xlwNLACutU+7FnjdfrwAuEJEkkRkODAaWNbhmndA4MLStrboiwZjDH//ZCcA/ZrN049nGckJPH3dDJ66fgbTh+a0/4IY8q1/2H+0pp0zlVI+nTFP/x7gbBHZBpxtP8cYswF4EdgILARuMsZ0WdYxr9dwqLzWH4CLKzp3z9Uthyp48rNdABw/JLtT3yvaslITOG1MXtxt4N7cmPwMkhMcfLGja7/BKdWdRSXoG2OWGGMush8fNsbMMcaMtn+WBZx3tzFmpDFmrDHm7Wi8d6gOV9XT4DH+roviTl7G75vy+Pu5E8lMTujU9+qtEl0O5ozL51+r98W6KioMNz27kkc/3B7ravRavWZF7kE7CB9nr/A81Mkt/XJ2M0IAAB8tSURBVFL7+rPHRG9MQrU0YWAmFbVufxpoFf/eXHeAe97eHOtq9Fq9Juiv3XcUoMMt/Zp6D797YyNPL90V0vmH7RklfdO7T39+d5SVYn2LOqYbpysVku4zraSD/vDWJo5U1bP3SDV5GUmcOCwXgLve3MRJw/sEze0SzJ0L1vPi8iJy0xK5ZtawNs8tqajjX6v2kZHs6lYzd7qjwKCfnxk/G82r4DRtRuz1+Jb+Yx/t4KUVRXy+o4yZI/o02e/1N29sCPk6Ww5VAlBe04Db0zLzY6DLHvmMzQcryNNWfqfTln73Ul3fOGuuoZ1/R6pz9PigH+i0Zv3rWw9VhPzaCjuouL3GP0jb3KeFpfzpnc3sKbN2nwrMD686h2+ufmFxZYxrokJRHbBNqP6hjo0eGfRLKuparNIck5/O5dOaphkIZwCwvNbNiL5WWoLALQUD/fi5VTz0gTUr4fYLxvPLC8aHW3UVpvEDMhmbn8EzS3fzwpd7+HBr9FZwq+irDFgfc+EDH/sfB9s3QXWOHhf0P9lWyol3v8fsez8AICc1gbyMJJ79zkz/OR/fegZXzxwCwFWPf8Gx6qYtjp2lVRhjMMbw8ooiFm86RHltAxPt5GOfbi/F6zUtEn0F/uKO6peO6nxOh3DupP5sPFDOL15Zx3ee+jLWVVKtqKhtYM6fP/Q/P1ReR2Wdm0eWbGfGH95jb1nwxpSKrh43ynj1378AoKLOzTceXcqR6ga+d9qIJrtXDc5N5atTBvLPz/ewYvcR3tl4kG9MtzJE7Cyt4oz7lnDVSUO44dTh/PylNf7Xjc1Pp2xUHx5Zsp1Hlmzne7NH8On2UpwOB1+bOoiKOjfnTsxnVL90vjI6vlMY9CQ5qY3rIBo8OlAYr5bvPtKibMvBcv5roTV9c8nWEr41c2hXV6vX6VEt/Tp3066aZbusdWHpQRKeTR3SmGJg/9EaLn34U77cVcY2u5//2S/2tEjMNjg3lQeumOp//tePdrB+Xzlr9h7lzgXWoPDl0wbzn+eOi8stEXuq5ovfFqyxUjp5vVZW1Y37dYeteHDgaOMeDfd9/TgALnuk8d/Y4crOXTujLHHf0g9n0c2+I1YOlvu/cRy/+/dGjtrdNtmpLVfEJrocrLrjbKb+fhFLtpSweu9Rvv5o0yBfWmmNCzz7nZNIdDmYPjQHEeHhq07g9tfWcaRZt9AZY/OYPUZb+F0tI7npr/GPn1uFMYabn18NwOLNxbz541NJcnWPFNc91YFjNTgExvXPaJGPyiFQqkG/S8R90N8WxqwMXz6d/pnJLP7padS5vazbd4xTW8kWmZOWyKDsFNYUHW1SPq5/BrdfOJ631x/E5RBOHtmnSR6aCyYP4PxJ/Vm64zAuh4Nv/HUp04bm8I/revSeMHHLt6H6oOwU9tnJ1574dJf/eGFxJQ9/sJ1bzh4Ti+r1GsYY7nt3C3OPH8SY/IwWx/cfrSU/MxmX00G/zGR+fdEEHvtoB187YRDvbjxEaYVmS23P66v38X9f7OHCKQP46pSB5Niz18IR90Ef4IMtxZwxtl+755XYQb9vRhJ97DnyA7NT2nzN+AEZ/kDhs/AnswH4yujWUyiICCePtP6YLP7ZaU3GDFTXykmzvsl9Y/pg/vu9rQCs2dv4h3xEXhqLNh7SoB9lb6zZT1qSkzPHWVOT/732AA99sJ13Nxxi0U9Pa3JuSUUdB8tr6J/VuIDu+lOHc/2pwwFr+nQ4U6h7K9+31y92lnGsuoHvnTaSRFd4XcndouP55udWteivD8Y3VzucRVHjB2R2uF4+I/PSNalaDE0bmstL35/FD88cxbLb5/jLr5k1lGdumMGkgVlNFgWp6PjRc6u4/snlgJXW5EfPrQKsb+fbSxq/oX+wpZgT736PTwsPMzAreCNs1si+7Cit4rPtpZ1f8W7qy11Ns8n+edFWJv/mnbBTysR90M9OTaC81s2nhe3/Mryxdj/D+6YF7cNvTWDLA2B43/jdIlC17sRhuTgdQr+MZHb84QKeuWEGt50/jq+MziM10UmNJmTrNFV1blY0m5nz69fXA1aXz5MBXW0TBgZvZF110hD6pCXy3LK9QY8rgm7zWuf2srboWFjXifvunYLsVI45hOW7jvi/RgZT2+BhV2kVPzpzdFh54C87oYDtxVWcNaEfw/umkdpNtjZUrXM4pEnXXHKCs8lKUBW5wDUqE+98B5dDSHQ6uOOi8dzx+ga2HLRa+g++X8iHW0u46qQhjMxL54oZg4NeLznByYSBmf7V7Kql8poGklwOfnvxRG57dZ2/fMuhirBW/8d9hBOxBlwf/XA7/3nu2FYD+p6yarwm/M28kxOc/PqrE6JRVRWnUhOd1DQL+l6v4YH3tzFrRB9OGhHfewHHo4pmO8+5vYYZw3L41qxhHKlu4P5FW7nvnS0s2VrMiLw0fnPxRBLamcaclZKgC7TaUF7bQGZKAlfMGML0YTnUub1875kVbD5ojYV4vIaPtpZw+ti2N0CK++4dsAaBvAbWFB1j/9EaLn/ksxa/HGV22gVNcqaaS0104vaaJiuml+0q4y/vbeM/HvtcE391wNGqlnlz5s0eAcCQ3FQAHvygkPX7yjlpeG67AR+soK/5eFpXXuP2Jxgc1S+DiQOzGNc/gy0HrXUoDyzexnVPfslH29ruCu8WQf+er00GYPOBcj7ZVsry3Ue4/skv8QakafXNyc8Koz9f9Q6+zKqBrX3fmg6AL3eWsb2kskVaDdU632b0EwZk8swNM7h65hBOG2t1qZ03qT83nDrcvyf11SGuss1KscbvWrsPq/Yc6dV/FI7VNJDZbE3K2P4Z7Cipot7tZYmdd6q9PaO7RdD/xvTBJDod7DxcRXKi9Q94W3Elt76yFrBW8r236RAA2anhz1tVPZtvnGb9/sYBr5KAhUBXPv4Fc/78IX//ZCder6GqTmf6tOeIHfR/f8kkvjI6j7sumexvzScnOLnjogms+825LLt9DhMHhrZnRXZqAh6v4ZonlnHLC6ubHFuz9yiXPvwZ819dG90P0k0YY9h6qKLFpkyTB2Xh9hrm3L/EP0151+GqNq/VLYK+wyHUe7z89cMdrLMXUo3rn8HLK4r4ZFspd725iZdXFAGQnaItfdXU+AHWQqF3NxykuLyWP7y1iZW7j5Cc0PTX/643NzHil28x8c53WL5LN1tvy1E76Oe08c06PclFv4zQN7Y5f9IAAD7eVsprq/Zx/6Kt/m1O315/EIC31h3s0NaYhyvruvUGLr/790aKK+r8O//5nDU+n/6Zyewta2zdH65se5Fbtwj6gf728U4A/nHdifRNT+TlFXv9vwTThuaQmqhL7VVTU4fkMKUgi8KSSn77xkYe+2gH7248REFOqv+cp65vupr6u08v54HF2/wL/gIZY1i4/iBn3/8hRUd658Bjmd2nn9uBFaGtGZyb2uT5A4u3MfOPi/nbRzuabKT+r1X7wrrusZoGTvrDYs64bwkVtd2ve2hHSSX/+HQXA7KSuXLGkCbHXE4Hz373JCYPyuKS4wcyrE+qf3yzNR0O+iIyWEQ+EJFNIrJBRG62y3NFZJGIbLN/5gS8Zr6IFIrIFhE5t6PvDZCdksjofhnsLqumweNlXP8MXrnx5LCma6rewxrwqmgyn3xAVjL/uukU7r50EqeNyePdW2az6Xfn8duLJ/pnoARmWfV5e/1Bvv/PFWwrruTGf64M+oehp9t9uIq0RGfUFyXefsF4bj1vLGeNb1yBf/dbm+ibnsjrN53CwKxkbnt1HQ8s3hbyNZ9Zugu317CnrNrfI9Cd+PaIePF7s4KmXRiZl84bPzqVv1wxlcG5nRj0ATfwM2PMeGAmcJOITABuAxYbY0YDi+3n2MeuACYC5wEPi0jIzfJ3b5lNUsBy4ySXg2F9U1m15yjvbSrW+b2qTWP7Z1JaWc/B8lqunjmEM8bmccOpwzl+cDZXnWQNNI7JzyAl0Ul+ZmO/6YdbS3htVRHltQ3+LJCBi2HW7TvGmfctYVdp2/2oPcmOkkqeXrqbiQOzcDii28j67uwR/OD0UTx01Qm899PTOHtCPjNH5PLmj7/CcYOz+e3cSYA1M2hnaVVI4y/vbSrmuIIspg3N4fGPd3a7AfuPt5UyvG9ai29CweSmJXLgWE2bM9I6HPSNMQeMMSvtxxXAJmAQMBd4yj7tKeAS+/Fc4HljTJ0xZidQCIScoWxMfgZXnmR9tRGx+vkvmDzAf1wX36i2nDyycS7+hAFZ/OO6GZzeSj6n5oNlt7ywhim/eZdpd73HsNve9Hc1rPvNOTx53YnUuj088/nuzqt8nHlkifX5z5nYeduBJrmcjOqXzt+umc7z82b5N70/e0I+C354CvVuL9c88QVTfvtui9XAgYwx7CipZJLd/bHvaA1FR5rObqlt8ASdAv72ugPR/2AdsHF/OVOHZLd/InD+pP4cKq/z36NgotKnLyLDgKnAF0C+MeYAWH8YAN+/rEFA4BrrIrss2PXmichyEVleUtK4/d1MexGN7w/1V0bn8doPTuY/zx3LC/NmBruUUoCVY8nX/5yb1naXhG+eeVZKAr+bO5HzJ/Vv8kcD4MLJA8hITuD0sf0YkpvKgWNtT5PrSVxOq3V//SnDY/L+vl3p9pbV4PEaLnvkM877y0dBF3YVHamhvNbNmPwMRuZZrwtMsLi3rJpxdyzkK/d+0GSg95YXVnPjsyu59eU1VNW5eXhJIfcu3MznOw536TeFJz7ZycHyWgZkhTYgft6kAZwyqg//Xru/1XMiXpErIunAK8BPjDHlbfSpBzsQ9P+eMeYx4DGA6dOn+88J9sGnDslpsiGKUq0Zk5/O5zvK2s2r3y8zmc/nzyEtyUlGcgLXzBrmP/bm2gOM7Z/RZDvMvIwkisu7d7/+gjX7WbB6H/defly7g7NHqhoY3S896l07oQpMlXL2hHw2HShn88EKfv7SGp6fNxOvsVrqH2wuZumOwwCcMqovbq/V5XG4sp5PC0sZkZfGxwELmY7/7bu8+oOTGZ2fwWZ7wdOLy4t4cXnjOMDDdgt66pBs/nT5FEb1a5lCOlpeW1XE7/69EbC+nYZqTH4Ga/e2no8noqAvIglYAf9ZY8yrdvEhERlgjDkgIgOAYru8CAhMvFEAtP7nKIg+utpWReCbM4bw+Y4yhvZpv2+0eSI+nwunDGhR1i8jmQVr9vPwkkJ+cPqoiOvZlYrLa3l5ZRH3LtwCwK0vr+Xxa6dTVeemvLaBnNRE/+I2gMc/3sHCDQeZMSw3VlUG4MnrTuShDwr59UUTGJybym8WbODJz3bxg2dX8s6Gg4iIv+U+9/iBjOqXTnGFNf3z9dX7eHfjoRbXrKhz8+AHhVwza5i/YTAkN5U9ZdWMzc8gJy2Bz3eUkZroZNWeo5z/Px+z9s5zSYnSjMH3Nx8iLz2ZyQVZ1DZ4uOUFaxLBry4cz/mT+od8nbREF1VtZJXtcNAXq0n/d2CTMeb+gEMLgGuBe+yfrweU/5+I3A8MBEYDy8J5zz5RnB6mep+5xw/inAn9o/aP1OfCKQNYsGY/9y7cwhlj+0UlXXdX+dlLa5q0djfsP8YXOw7zH499DlhBb/HPTiPB6WBvWTV3vbkJiO5UzY44fWy/JmMy50zM58nPdvnn82MM3zl1OF4DV8+0xgJz7YWbvoCf4BQaPIb7v3EcJw7L5YlPd/KPT3fx+mqrLXrNrKHccdEEDh6rpW96EimJTrxeQ73Hy28WbOD5L/cy75nlPHPDSRF9FmMMz3+5l/l2ErXFPzuNV+xZRvPPH2evbg79W1Vakou2liRE0tI/BfgWsE5EfMvnfokV7F8UkRuAPcDXAYwxG0TkRWAj1syfm4wxYY2++locN54+MoJqq94s2gEf4NyJ/TlrfD7vbTrEjpKqmAX92gYPb68/wNzjBoXc9RI46+27XxnO3z7e6Q/4vuNvrTvAhAGZnP3fH/nLv33KsKjVOxomDWrs/rjrkkmMyc9gxvCm30ZcTgdj8tPZeqiSey+bwjkT81m15yinjcnD4RB+fdEEJg3M4r53t3DgWC2VtW4SnI4ms2YcDiHZ4eSey6bgcAgvfGmtEwr8NhSuL3cd8Qd8gDl//pDURCcXTh7AvNkjwp6GnpbUdl06HPSNMZ8QvJ8eYE6wQmPM3cDdHX1PgF33XBjJy5XqFH/82mTeu/sQh6tC69svr23g5eVFfPvkYTgcQmFxBf/7vtW1MG1ox8ao7vjXel5aUcTArJSQM4f6UidcO2so3z9tJGv2HiMvM4lzJuTz1SkDmXbXIv9uTT5b7jov7vYbzkxOYOn8M0lyOdv8FvLaD06hut7j3+nujHGN3xZEhMumFTB+QCYXPPBxu3+8TxnZl//7Yg9bDlaQmZJAbmpih3J/7Sy10lCfNT6fqUOyefiDQqrqPdx8Vnhp4n3aSw8f96mVleoOclITEIHSdpbA+/zxrU08t2wvo/qlk+Ry+FvXr6/ez/999yT/VpyhMsbw/mZr+OxIdeirTqvr3Jw7MZ/fXDwREeHF789qcnx0foZ/845ZI/rwywvGx13A9xnQyq5cgdKSXKQltR32JgzM5IOfn+6fxdWaE4dZf5znPvQpYGVznTM+nzPH5ZGfkczJrezN3ZxvEsCDV04lOcFq4RcWVwbdZzgU6Z3V0ldKNXI5HeSmJlJSEdrWdb6ssE8v3c2K3VZQ/eaMISxYvY+bn1/Nl7efFfJ7FxZXcPmjS/3XDEwm57NqzxEWbjjIbeeN87cev9xVxv5jtVx8/KBWW5R//vpx/PPz3QzKSWkyi6mnC2UHvX6ZyVx3yjD+Ye8MVl3v4Y01+3ljjTUm8O2ThzH3+IGtzi5cvOkQNz67knq3l4wkl7+LaFjfNIZFsIOftvSV6iIj+6W3uVAokG91uS87bKLLwR8unURBTgp/emdLWP3EizYWc7S6gbMn5LNo4yHue2cLEwZksnR7KRV1bq47eTg3PbuS/cdqWbj+IN85dTjV9R7++PZmAPpntj4rbnBuKvMvGB9SPXqjO786ka9NLaAgJwWvPSCbnZrAwvUHeXrpLp78bBdPXz+D2WOstNP7j9ZQ2+Ah0eXghqeW+6/T2o5iHTEwO4VLpw7iL60c16CvVJScMCSHRz/czpe7yjixnSmNzWdXfMeeoeFbefrYRzu4eubQkGbJbDxQzqDsFP52zXTmv7qW55bt5bJHPvMf/+uHO/yPdx+u5o7XN/if/+Ss0Vw+PXoBpzeaXNA4iHzTGdaU3atOGkpZVT0n/H4R1zyxjLyMJPqkJfp3uQLrD/8VJw7mP04c0urewR0xql86//0fx/OXK4If16CvVJR8b/YIHv1wO7e8sJqzxuczb/YIBmYH72f2pQxOT3Lxzi2zGWSf51uAeP+irdy/aCs/PnMUN581Bmez2TjGGBas2U/RkRreWLOfs+09Uv/4tSnMv2A8c/78ISUVdSz+2Wk8/vFO9pRVcd/XrYVXH24p4a11B/jhmaM6dXFRb5eblsi82SN47KMdlFTUtUjMd+/lU5h7fNCkBJ1K4j350PTp083y5cvbP1GpOHDC7xc1yXL42Lemcc7EpgtrPtteypV/+4LzJ/XnkaunNTnm9nj56YtrWLCmcd1iv4wkfv3VCZw1Pt/f5XPNE8v4aGtjipL/PHesv5UJUFXnpqyqPqQkXapzbdh/jE8LS1m2s4zSynr+ds10KmobGJGX3v6LIyAiK4wx01uUa9BXKnqKjlRz6n994H+enuRi0U9nN5lZMufPS9heUsX3TxvJbeePa/VaK/cc4aZnV3LA/lYwc0Qud37V2mD8rPs/BKxgf1xBNicOz4nbWTUqNloL+t1uExWl4llBTiq3nDWGwbkpLPn56XiN4Y5/rfcfr653s6esmtlj8vjxnLZTNpwwJIdPf3Emq+44m+9+ZTif7yjj/P/52B/wv/uV4dx0xihOHd1XA74KmQZ9paLs5rNG8/GtZzKsbxrXzBrGe5uKeeiDQqsffvV+GjyGH505qt2pdWCtAM1JS+RHc0YzfWgO50/qz8XHDSQ9ycWskaEtwFIqkA7kKtWJLp9WwKMfbudP72yhut7N5zvKGN0vnelhrrrNTE7g5RtP7qRaqt5EW/pKdaJR/dL5+NYzmDY0h4c+2M6K3UeYPSZPt/VUMaNBX6lONjg3lRfmzeRbM4eSkeTi0qldP01PKR+dvaNUF/J4TYs590p1Bp29o1Qc0ICvYk2DvlJK9SIa9JVSqhfRoK+UUr2IBn2llOpFNOgrpVQvokFfKaV6EQ36SinVi8T94iwRqQC2hHBqFnAsxMuGem60zwvn3L5AaRSv2dP+//S0z6P3O36v2V3v91hjTMtdcowxcf0fsDzE8x4L45ohnRvt88K8ZkifO9Rr9sD/Pz3t8+j9jtNrdtf73dp79KTunTc64dxonxfuudG8Zk/7/9PTPk849H537TV71P3uDt07y02Q/BE9XW/93L2V3u/epSvud2vv0R1a+o/FugIx0ls/d2+l97t36Yr7HfQ94r6lr5RSKnq6Q0tf9VAiUtnO8SUiol0ePYTe7/igQV8ppXqRuAr6vbEl0N5n7ulE5HQR+XfA8wdF5NsxrFKn0vut9zvW4iroK6WU6lxxF/R7W0sAQETSRWSxiKwUkXUiMtcuHyYim0TkbyKyQUTeFZGUWNdXRUbvd+8Sb/c77oJ+L1ULXGqMOQE4A/iziPj21RsNPGSMmQgcBS6LUR07i5umv4fJsapIF9L73Ujvdxffb1dnv4EKiQB/EJHZgBcYBOTbx3YaY1bbj1cAw7q+ep1qNzBBRJKwAsAc4JPYVqnT6f3W+x2z+x2PQb83tgSuAvKAacaYBhHZRePnrgs4zwP0iK/7IuIC6owxe0XkRWAtsA1YFduadQm933q/Y3a/4zHo98aWQBZQbP9CnAEMjXWFusBEYDuAMeZW4NbmJxhjTu/iOnUVvd96v2MmboJ+b2wJ+D4z8CzwhogsB1YDm2NasU4mIt8Hfgz8JNZ16Up6v/V+Ewf3O27SMIjIccDfjDEzYl2XrtIbP3Nvpve7d4nX+x0Xs3fslsBzwK9iXZeu0hs/c2+m97t3ief7HTctfaWUUp0vLlr6vYGIDBaRD+zFGBtE5Ga7PFdEFonINvtnjl3exz6/UkQebHatb9qLPNaKyEIR6RuLz6RaF+X7/R/2vd4gIvfG4vOotnXgfp8tIivsf8crROTMgGtNs8sLReSBgDn9UaFBv+u4gZ8ZY8YDM4GbRGQCcBuw2BgzGlhsPwdrQccdwM8DL2IPDv0PcIYxZgrWgPcPu+YjqDBE6373Af4EzLEX8OSLyJwu+gwqdOHe71Lgq8aYycC1wDMB13oEmIe1cGs0cF40K6pBv4sYYw4YY1bajyuATViLNOYCT9mnPQVcYp9TZYz5BCsYBBL7vzS7BZAJ7O/8T6DCEcX7PQLYaowpsZ+/R89bpdvtdeB+rzLG+P7dbgCSRSRJRAYAmcaYpcbqe3/a95po0aAfAyIyDJgKfAHkG2MOgPWLA/Rr67XGmAbgRmAdVrCfAPy9E6urIhTJ/QYKgXF2nhYXVgAY3Hm1VZHqwP2+DFhljKnD+kNRFHCsyC6LGg36XUxE0oFXgJ8YY8o78PoErKA/FRiI1b0zP6qVVFET6f02xhzBut8vAB8Du7C6ElQcCvd+i8hE4L+A7/mKgpwW1dk2GvS7kB2wXwGeNca8ahcfsr/SYf8sbucyxwMYY7bbX/9eBE7upCqrCETpfmOMecMYc5IxZhawBWvRoooz4d5vESkAXgOuMcZst4uLgIKAyxYQ5e5bDfpdxO5//zuwyRhzf8ChBVgDOdg/X2/nUvuw0lTk2c/Pxuo/VHEkivcbEeln/8wBfgA8Ht3aqkiFe79FJBt4E5hvjPnUd7LdBVQhIjPta15DCL8jYdVV5+l3DRE5Fevr+TqsTHsAv8Tq93sRGALsAb5ujCmzX7MLa6A2ESvt6jnGmI32wo+bgQasXEXfNsYc7rpPo9oT5fv9HHCcfY3fGWOe76rPoUIT7v0WkV9hdcsGfms7xxhTLNbugE9iJV97G/iRiWKg1qCvlFK9iHbvKKVUL6JBXymlehEN+kop1Yto0FdKqV5Eg75SSvUiGvSVCiAiHhFZbWdKXCMiPxWRNv+d2CkSruyqOioVCQ36SjVVY4w53s5oeTZwAXBnO68ZBmjQV92CztNXKoCIVBpj0gOejwC+BPpibWj9DJBmH/6hMeYzEfkcGA/sxMqk+ABwD3A6kAQ8ZIz5a5d9CKXaoEFfqQDNg75ddgQYB1QAXmNMrYiMBp4zxkwXkdOBnxtjLrLPnwf0M8bcJSJJwKdYKzF3dumHUSoIV6wroFQ34Mt8mAA8KCLHAx5gTCvnnwNMEZHL7edZWJthaNBXMadBX6k22N07HqzsiHcCh7Dy4DhoueGJ/2VY+VLe6ZJKKhUGHchVqhV2JtNHgQfthFdZwAFjjBf4FuC0T60AMgJe+g5wo51qFxEZIyJpKBUHtKWvVFMpIrIaqyvHjTVw60uV+zDwioh8HfgAqLLL1wJuEVmDlR3xf7Bm9Ky00+OWEOUt75TqKB3IVUqpXkS7d5RSqhfRoK+UUr2IBn2llOpFNOgrpVQvokFfKaV6EQ36SinVi2jQV0qpXkSDvlJK9SL/D8yMrGwgtb7oAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# plotting the graph for the daily max data we have which is stored in daily max variable\n",
    "\n",
    "# importing matplotlib below\n",
    "%matplotlib inline  \n",
    "\n",
    "dailymax.plot() # plotting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Close</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017-07-02</th>\n",
       "      <td>268.202162</td>\n",
       "      <td>293.73</td>\n",
       "      <td>253.23</td>\n",
       "      <td>8.084631e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-09</th>\n",
       "      <td>261.062083</td>\n",
       "      <td>285.00</td>\n",
       "      <td>231.25</td>\n",
       "      <td>2.246746e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-16</th>\n",
       "      <td>195.698393</td>\n",
       "      <td>240.33</td>\n",
       "      <td>130.26</td>\n",
       "      <td>5.017750e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-23</th>\n",
       "      <td>212.783750</td>\n",
       "      <td>249.40</td>\n",
       "      <td>153.25</td>\n",
       "      <td>7.221637e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-30</th>\n",
       "      <td>203.309524</td>\n",
       "      <td>229.99</td>\n",
       "      <td>178.03</td>\n",
       "      <td>2.657305e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-02-16</th>\n",
       "      <td>255.198452</td>\n",
       "      <td>290.00</td>\n",
       "      <td>216.31</td>\n",
       "      <td>3.912867e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-02-23</th>\n",
       "      <td>265.321905</td>\n",
       "      <td>287.13</td>\n",
       "      <td>242.36</td>\n",
       "      <td>3.067838e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-01</th>\n",
       "      <td>236.373988</td>\n",
       "      <td>278.13</td>\n",
       "      <td>209.26</td>\n",
       "      <td>3.693920e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-08</th>\n",
       "      <td>229.817619</td>\n",
       "      <td>253.01</td>\n",
       "      <td>196.00</td>\n",
       "      <td>2.736569e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-15</th>\n",
       "      <td>176.332821</td>\n",
       "      <td>208.65</td>\n",
       "      <td>90.00</td>\n",
       "      <td>4.983998e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>142 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Close    High     Low        Volume\n",
       "Date                                                \n",
       "2017-07-02  268.202162  293.73  253.23  8.084631e+07\n",
       "2017-07-09  261.062083  285.00  231.25  2.246746e+08\n",
       "2017-07-16  195.698393  240.33  130.26  5.017750e+08\n",
       "2017-07-23  212.783750  249.40  153.25  7.221637e+08\n",
       "2017-07-30  203.309524  229.99  178.03  2.657305e+08\n",
       "...                ...     ...     ...           ...\n",
       "2020-02-16  255.198452  290.00  216.31  3.912867e+08\n",
       "2020-02-23  265.321905  287.13  242.36  3.067838e+08\n",
       "2020-03-01  236.373988  278.13  209.26  3.693920e+08\n",
       "2020-03-08  229.817619  253.01  196.00  2.736569e+08\n",
       "2020-03-15  176.332821  208.65   90.00  4.983998e+08\n",
       "\n",
       "[142 rows x 4 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# resampling multiple columns\n",
    "df.resample(\"W\").agg({\"Close\": \"mean\", \"High\": \"max\", \"Low\": \"min\", \"Volume\": \"sum\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3rc1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
